The former England cricket star has candidly opened up after he suffered a serious accident while filming for Top Gear in 2022